Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	1156772
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	207.4 MiB
Average record size in memory	188.0 B

Variable types

Numeric	17
Categorical	7

Warnings

`addr_state` has a high cardinality: 51 distinct values	High cardinality
`loan_amnt` is highly correlated with `installment` and 1 other fields	High correlation
`installment` is highly correlated with `loan_amnt` and 1 other fields	High correlation
`loan_status` is highly correlated with `ROI`	High correlation
`open_acc` is highly correlated with `total_acc`	High correlation
`total_acc` is highly correlated with `open_acc`	High correlation
`total_pymnt` is highly correlated with `loan_amnt` and 2 other fields	High correlation
`ROI` is highly correlated with `loan_status` and 1 other fields	High correlation
`loan_amnt` is highly correlated with `installment` and 1 other fields	High correlation
`installment` is highly correlated with `loan_amnt` and 1 other fields	High correlation
`loan_status` is highly correlated with `ROI`	High correlation
`open_acc` is highly correlated with `total_acc`	High correlation
`total_acc` is highly correlated with `open_acc`	High correlation
`total_pymnt` is highly correlated with `loan_amnt` and 2 other fields	High correlation
`ROI` is highly correlated with `loan_status` and 1 other fields	High correlation
`loan_amnt` is highly correlated with `installment` and 1 other fields	High correlation
`installment` is highly correlated with `loan_amnt` and 1 other fields	High correlation
`loan_status` is highly correlated with `ROI`	High correlation
`open_acc` is highly correlated with `total_acc`	High correlation
`total_acc` is highly correlated with `open_acc`	High correlation
`total_pymnt` is highly correlated with `loan_amnt` and 2 other fields	High correlation
`ROI` is highly correlated with `loan_status` and 1 other fields	High correlation
`open_acc` is highly correlated with `total_acc`	High correlation
`loan_status` is highly correlated with `ROI`	High correlation
`term` is highly correlated with `ROI` and 1 other fields	High correlation
`total_pymnt` is highly correlated with `installment` and 2 other fields	High correlation
`installment` is highly correlated with `total_pymnt` and 2 other fields	High correlation
`total_acc` is highly correlated with `open_acc`	High correlation
`ROI` is highly correlated with `loan_status` and 4 other fields	High correlation
`loan_amnt` is highly correlated with `term` and 3 other fields	High correlation
`annual_inc` is highly skewed (γ1 = 47.28305342)	Skewed
`emp_length` has 98508 (8.5%) zeros	Zeros
`delinq_2yrs` has 930540 (80.4%) zeros	Zeros
`inq_last_6mths` has 661742 (57.2%) zeros	Zeros
`pub_rec` has 961673 (83.1%) zeros	Zeros

Reproduction

Analysis started	2021-07-15 03:26:13.364833
Analysis finished	2021-07-15 03:31:51.891973
Duration	5 minutes and 38.53 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

loan_amnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1549
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14294.20828

Minimum	500
Maximum	40000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	500
5-th percentile	3175
Q1	7800
median	12000
Q3	20000
95-th percentile	32225
Maximum	40000
Range	39500
Interquartile range (IQR)	12200

Descriptive statistics

Standard deviation	8677.84587
Coefficient of variation (CV)	0.6070882486
Kurtosis	-0.02323530406
Mean	14294.20828
Median Absolute Deviation (MAD)	5825
Skewness	0.8065039352
Sum	1.65351399 × 10¹⁰
Variance	75305008.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	86761	7.5%
12000	64025	5.5%
15000	60165	5.2%
20000	59788	5.2%
5000	42559	3.7%
35000	42349	3.7%
8000	42230	3.7%
6000	39661	3.4%
16000	31853	2.8%
25000	28528	2.5%
Other values (1539)	658853	57.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
500	2	< 0.1%
800	1	< 0.1%
950	1	< 0.1%
1000	5004	0.4%
1025	14	< 0.1%
1050	35	< 0.1%
1075	16	< 0.1%
1100	130	< 0.1%
1125	28	< 0.1%
1150	27	< 0.1%

Value	Count	Frequency (%)
40000	6115	0.5%
39975	4	< 0.1%
39950	2	< 0.1%
39900	6	< 0.1%
39875	1	< 0.1%
39850	2	< 0.1%
39825	3	< 0.1%
39800	3	< 0.1%
39775	5	< 0.1%
39750	3	< 0.1%

term
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

36 months	879067
60 months	277705

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	11567720
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36 months
2nd row	36 months
3rd row	60 months
4th row	60 months
5th row	36 months

Common Values

Value	Count	Frequency (%)
36 months	879067	76.0%
60 months	277705	24.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
months	1156772	50.0%
36	879067	38.0%
60	277705	12.0%

Most occurring characters

Value	Count	Frequency (%)
	2313544	20.0%
6	1156772	10.0%
m	1156772	10.0%
o	1156772	10.0%
n	1156772	10.0%
t	1156772	10.0%
h	1156772	10.0%
s	1156772	10.0%
3	879067	7.6%
0	277705	2.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6940632	60.0%
Space Separator	2313544	20.0%
Decimal Number	2313544	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	1156772	16.7%
o	1156772	16.7%
n	1156772	16.7%
t	1156772	16.7%
h	1156772	16.7%
s	1156772	16.7%

Decimal Number

Value	Count	Frequency (%)
6	1156772	50.0%
3	879067	38.0%
0	277705	12.0%

Space Separator

Value	Count	Frequency (%)
	2313544	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6940632	60.0%
Common	4627088	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	1156772	16.7%
o	1156772	16.7%
n	1156772	16.7%
t	1156772	16.7%
h	1156772	16.7%
s	1156772	16.7%

Common

Value	Count	Frequency (%)
	2313544	50.0%
6	1156772	25.0%
3	879067	19.0%
0	277705	6.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11567720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2313544	20.0%
6	1156772	10.0%
m	1156772	10.0%
o	1156772	10.0%
n	1156772	10.0%
t	1156772	10.0%
h	1156772	10.0%
s	1156772	10.0%
3	879067	7.6%
0	277705	2.4%

installment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	78622
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	434.0155144

Minimum	4.93
Maximum	1719.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	4.93
5-th percentile	107.95
Q1	246.99
median	371.07
Q3	573.32
95-th percentile	956.35
Maximum	1719.83
Range	1714.9
Interquartile range (IQR)	326.33

Descriptive statistics

Standard deviation	259.5520317
Coefficient of variation (CV)	0.5980247782
Kurtosis	0.8086749356
Mean	434.0155144
Median Absolute Deviation (MAD)	153.13
Skewness	1.024974036
Sum	502056994.6
Variance	67367.25718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
327.34	2683	0.2%
301.15	2443	0.2%
332.1	2325	0.2%
318.79	2018	0.2%
312.86	1896	0.2%
361.38	1842	0.2%
451.73	1762	0.2%
392.81	1757	0.2%
602.3	1750	0.2%
491.01	1696	0.1%
Other values (78612)	1136600	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.93	1	< 0.1%
14.01	1	< 0.1%
14.77	1	< 0.1%
16.25	1	< 0.1%
16.31	1	< 0.1%
19.87	1	< 0.1%
20.22	1	< 0.1%
21.25	1	< 0.1%
21.62	1	< 0.1%
21.74	1	< 0.1%

Value	Count	Frequency (%)
1719.83	1	< 0.1%
1717.63	1	< 0.1%
1715.42	1	< 0.1%
1618.03	1	< 0.1%
1607.8	2	< 0.1%
1587.23	2	< 0.1%
1584.9	1	< 0.1%
1569.11	3	< 0.1%
1568.25	1	< 0.1%
1566.8	7	< 0.1%

grade
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.729148873

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	5
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.280707666
Coefficient of variation (CV)	0.4692699906
Kurtosis	0.1377284728
Mean	2.729148873
Median Absolute Deviation (MAD)	1
Skewness	0.6303438821
Sum	3157003
Variance	1.640212126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	336447	29.1%
2	334062	28.9%
1	205333	17.8%
4	170523	14.7%
5	77467	6.7%
6	25802	2.2%
7	7138	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	205333	17.8%
2	334062	28.9%
3	336447	29.1%
4	170523	14.7%
5	77467	6.7%
6	25802	2.2%
7	7138	0.6%

Value	Count	Frequency (%)
7	7138	0.6%
6	25802	2.2%
5	77467	6.7%
4	170523	14.7%
3	336447	29.1%
2	334062	28.9%
1	205333	17.8%

emp_length
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.967095504

Minimum	0
Maximum	10
Zeros	98508
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.693057306
Coefficient of variation (CV)	0.6189036699
Kurtosis	-1.500871438
Mean	5.967095504
Median Absolute Deviation (MAD)	4
Skewness	-0.21735933
Sum	6902569
Variance	13.63867227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
10	404499	35.0%
2	111509	9.6%
0	98508	8.5%
3	98359	8.5%
1	81044	7.0%
5	76506	6.6%
4	73325	6.3%
6	57018	4.9%
8	55380	4.8%
7	54077	4.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	98508	8.5%
1	81044	7.0%
2	111509	9.6%
3	98359	8.5%
4	73325	6.3%
5	76506	6.6%
6	57018	4.9%
7	54077	4.7%
8	55380	4.8%
9	46547	4.0%

Value	Count	Frequency (%)
10	404499	35.0%
9	46547	4.0%
8	55380	4.8%
7	54077	4.7%
6	57018	4.9%
5	76506	6.6%
4	73325	6.3%
3	98359	8.5%
2	111509	9.6%
1	81044	7.0%

home_ownership
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

MORTGAGE	571621
RENT	465503
OWN	119302
ANY	259
OTHER	48

Length

Max length	8
Median length	4
Mean length	5.873291366
Min length	3

Characters and Unicode

Total characters	6794059
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MORTGAGE
2nd row	MORTGAGE
3rd row	MORTGAGE
4th row	MORTGAGE
5th row	RENT

Common Values

Value	Count	Frequency (%)
MORTGAGE	571621	49.4%
RENT	465503	40.2%
OWN	119302	10.3%
ANY	259	< 0.1%
OTHER	48	< 0.1%
NONE	39	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
mortgage	571621	49.4%
rent	465503	40.2%
own	119302	10.3%
any	259	< 0.1%
other	48	< 0.1%
none	39	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
G	1143242	16.8%
E	1037211	15.3%
R	1037172	15.3%
T	1037172	15.3%
O	691010	10.2%
N	585142	8.6%
A	571880	8.4%
M	571621	8.4%
W	119302	1.8%
Y	259	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6794059	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	1143242	16.8%
E	1037211	15.3%
R	1037172	15.3%
T	1037172	15.3%
O	691010	10.2%
N	585142	8.6%
A	571880	8.4%
M	571621	8.4%
W	119302	1.8%
Y	259	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6794059	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	1143242	16.8%
E	1037211	15.3%
R	1037172	15.3%
T	1037172	15.3%
O	691010	10.2%
N	585142	8.6%
A	571880	8.4%
M	571621	8.4%
W	119302	1.8%
Y	259	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6794059	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	1143242	16.8%
E	1037211	15.3%
R	1037172	15.3%
T	1037172	15.3%
O	691010	10.2%
N	585142	8.6%
A	571880	8.4%
M	571621	8.4%
W	119302	1.8%
Y	259	< 0.1%

annual_inc
Real number (ℝ_≥0)

SKEWED

Distinct	52633
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77545.7614

Minimum	33
Maximum	10999200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	33
5-th percentile	30000
Q1	47000
median	65000
Q3	92000
95-th percentile	158700
Maximum	10999200
Range	10999167
Interquartile range (IQR)	45000

Descriptive statistics

Standard deviation	71428.22134
Coefficient of variation (CV)	0.921110581
Kurtosis	4844.268239
Mean	77545.7614
Median Absolute Deviation (MAD)	21000
Skewness	47.28305342
Sum	8.970276551 × 10¹⁰
Variance	5101990803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	45123	3.9%
50000	40125	3.5%
65000	34174	3.0%
70000	32572	2.8%
40000	31300	2.7%
80000	31156	2.7%
75000	30473	2.6%
45000	29307	2.5%
55000	27690	2.4%
100000	23956	2.1%
Other values (52623)	830896	71.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
33	1	< 0.1%
100	3	< 0.1%
487	1	< 0.1%
600	1	< 0.1%
750	1	< 0.1%
800	1	< 0.1%
1000	4	< 0.1%
1066	1	< 0.1%
1200	1	< 0.1%
1400	1	< 0.1%

Value	Count	Frequency (%)
10999200	1	< 0.1%
9550000	1	< 0.1%
9522972	1	< 0.1%
9500000	1	< 0.1%
9300000	1	< 0.1%
9225000	1	< 0.1%
9000000	1	< 0.1%
8900060	1	< 0.1%
8706582	1	< 0.1%
8700000	1	< 0.1%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

Source Verified	469665
Not Verified	362340
Verified	324767

Length

Max length	15
Median length	12
Mean length	12.0950291
Min length	8

Characters and Unicode

Total characters	13991191
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Verified
2nd row	Not Verified
3rd row	Not Verified
4th row	Source Verified
5th row	Source Verified

Common Values

Value	Count	Frequency (%)
Source Verified	469665	40.6%
Not Verified	362340	31.3%
Verified	324767	28.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
verified	1156772	58.2%
source	469665	23.6%
not	362340	18.2%

Most occurring characters

Value	Count	Frequency (%)
e	2783209	19.9%
i	2313544	16.5%
r	1626437	11.6%
V	1156772	8.3%
f	1156772	8.3%
d	1156772	8.3%
o	832005	5.9%
	832005	5.9%
S	469665	3.4%
u	469665	3.4%
Other values (3)	1194345	8.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11170409	79.8%
Uppercase Letter	1988777	14.2%
Space Separator	832005	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2783209	24.9%
i	2313544	20.7%
r	1626437	14.6%
f	1156772	10.4%
d	1156772	10.4%
o	832005	7.4%
u	469665	4.2%
c	469665	4.2%
t	362340	3.2%

Uppercase Letter

Value	Count	Frequency (%)
V	1156772	58.2%
S	469665	23.6%
N	362340	18.2%

Space Separator

Value	Count	Frequency (%)
	832005	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13159186	94.1%
Common	832005	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2783209	21.2%
i	2313544	17.6%
r	1626437	12.4%
V	1156772	8.8%
f	1156772	8.8%
d	1156772	8.8%
o	832005	6.3%
S	469665	3.6%
u	469665	3.6%
c	469665	3.6%
Other values (2)	724680	5.5%

Common

Value	Count	Frequency (%)
	832005	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13991191	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2783209	19.9%
i	2313544	16.5%
r	1626437	11.6%
V	1156772	8.3%
f	1156772	8.3%
d	1156772	8.3%
o	832005	5.9%
	832005	5.9%
S	469665	3.4%
u	469665	3.4%
Other values (3)	1194345	8.5%

loan_status
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

1	931992
0	224780

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1156772
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

Most occurring characters

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1156772	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1156772	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1156772	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	931992	80.6%
0	224780	19.4%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

debt_consolidation	670735
credit_card	254847
home_improvement	74334
other	67747
major_purchase	25311
Other values (9)	63798

Length

Max length	18
Median length	18
Mean length	14.90281404
Min length	3

Characters and Unicode

Total characters	17239158
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	debt_consolidation
2nd row	small_business
3rd row	home_improvement
4th row	major_purchase
5th row	debt_consolidation

Common Values

Value	Count	Frequency (%)
debt_consolidation	670735	58.0%
credit_card	254847	22.0%
home_improvement	74334	6.4%
other	67747	5.9%
major_purchase	25311	2.2%
medical	13441	1.2%
small_business	12716	1.1%
car	12587	1.1%
moving	8437	0.7%
vacation	7959	0.7%
Other values (4)	8658	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	670735	58.0%
credit_card	254847	22.0%
home_improvement	74334	6.4%
other	67747	5.9%
major_purchase	25311	2.2%
medical	13441	1.2%
small_business	12716	1.1%
car	12587	1.1%
moving	8437	0.7%
vacation	7959	0.7%
Other values (4)	8658	0.7%

Most occurring characters

Value	Count	Frequency (%)
o	2276539	13.2%
d	1867988	10.8%
t	1746456	10.1%
i	1714945	9.9%
n	1448265	8.4%
e	1279673	7.4%
c	1239826	7.2%
_	1038747	6.0%
a	1031868	6.0%
s	753023	4.4%
Other values (12)	2841828	16.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16200411	94.0%
Connector Punctuation	1038747	6.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	2276539	14.1%
d	1867988	11.5%
t	1746456	10.8%
i	1714945	10.6%
n	1448265	8.9%
e	1279673	7.9%
c	1239826	7.7%
a	1031868	6.4%
s	753023	4.6%
r	716592	4.4%
Other values (11)	2125236	13.1%

Connector Punctuation

Value	Count	Frequency (%)
_	1038747	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16200411	94.0%
Common	1038747	6.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	2276539	14.1%
d	1867988	11.5%
t	1746456	10.8%
i	1714945	10.6%
n	1448265	8.9%
e	1279673	7.9%
c	1239826	7.7%
a	1031868	6.4%
s	753023	4.6%
r	716592	4.4%
Other values (11)	2125236	13.1%

Common

Value	Count	Frequency (%)
_	1038747	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17239158	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	2276539	13.2%
d	1867988	10.8%
t	1746456	10.1%
i	1714945	9.9%
n	1448265	8.4%
e	1279673	7.4%
c	1239826	7.2%
_	1038747	6.0%
a	1031868	6.0%
s	753023	4.4%
Other values (12)	2841828	16.5%

addr_state
Categorical

HIGH CARDINALITY

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

CA	168991
TX	95967
NY	94282
FL	80695
IL	44856
Other values (46)	671981

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2313544
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PA
2nd row	SD
3rd row	IL
4th row	PA
5th row	GA

Common Values

Value	Count	Frequency (%)
CA	168991	14.6%
TX	95967	8.3%
NY	94282	8.2%
FL	80695	7.0%
IL	44856	3.9%
NJ	41924	3.6%
PA	39288	3.4%
OH	37679	3.3%
GA	37077	3.2%
VA	32916	2.8%
Other values (41)	483097	41.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	168991	14.6%
tx	95967	8.3%
ny	94282	8.2%
fl	80695	7.0%
il	44856	3.9%
nj	41924	3.6%
pa	39288	3.4%
oh	37679	3.3%
ga	37077	3.2%
va	32916	2.8%
Other values (41)	483097	41.8%

Most occurring characters

Value	Count	Frequency (%)
A	396744	17.1%
C	260642	11.3%
N	259758	11.2%
L	152964	6.6%
T	145003	6.3%
M	139771	6.0%
I	121311	5.2%
Y	107825	4.7%
O	106092	4.6%
X	95967	4.1%
Other values (14)	527467	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2313544	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	396744	17.1%
C	260642	11.3%
N	259758	11.2%
L	152964	6.6%
T	145003	6.3%
M	139771	6.0%
I	121311	5.2%
Y	107825	4.7%
O	106092	4.6%
X	95967	4.1%
Other values (14)	527467	22.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2313544	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	396744	17.1%
C	260642	11.3%
N	259758	11.2%
L	152964	6.6%
T	145003	6.3%
M	139771	6.0%
I	121311	5.2%
Y	107825	4.7%
O	106092	4.6%
X	95967	4.1%
Other values (14)	527467	22.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2313544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	396744	17.1%
C	260642	11.3%
N	259758	11.2%
L	152964	6.6%
T	145003	6.3%
M	139771	6.0%
I	121311	5.2%
Y	107825	4.7%
O	106092	4.6%
X	95967	4.1%
Other values (14)	527467	22.8%

dti
Real number (ℝ)

Distinct	6379
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.14050433

Minimum	-1
Maximum	999
Zeros	590
Zeros (%)	0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	8.8 MiB

Quantile statistics

Minimum	-1
5-th percentile	5.01
Q1	11.76
median	17.53
Q3	23.93
95-th percentile	32.78
Maximum	999
Range	1000
Interquartile range (IQR)	12.17

Descriptive statistics

Standard deviation	9.615304137
Coefficient of variation (CV)	0.5300461313
Kurtosis	1231.736228
Mean	18.14050433
Median Absolute Deviation (MAD)	6.06
Skewness	14.65419916
Sum	20984427.47
Variance	92.45407365
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.2	864	0.1%
18	850	0.1%
16.8	838	0.1%
14.4	837	0.1%
15.6	792	0.1%
13.2	777	0.1%
12	762	0.1%
20.4	745	0.1%
21.6	727	0.1%
10.8	693	0.1%
Other values (6369)	1148887	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	590	0.1%
0.01	9	< 0.1%
0.02	15	< 0.1%
0.03	10	< 0.1%
0.04	7	< 0.1%
0.05	9	< 0.1%
0.06	21	< 0.1%
0.07	16	< 0.1%
0.08	13	< 0.1%

Value	Count	Frequency (%)
999	10	< 0.1%
831.97	1	< 0.1%
797.1	1	< 0.1%
771.31	1	< 0.1%
762.5	1	< 0.1%
669.23	1	< 0.1%
606.8	1	< 0.1%
602.67	1	< 0.1%
592.12	1	< 0.1%
586.79	1	< 0.1%

delinq_2yrs
Real number (ℝ_≥0)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3242229238

Minimum	0
Maximum	39
Zeros	930540
Zeros (%)	80.4%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	39
Range	39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8912197426
Coefficient of variation (CV)	2.748786952
Kurtosis	58.92139786
Mean	0.3242229238
Median Absolute Deviation (MAD)	0
Skewness	5.609803477
Sum	375052
Variance	0.7942726296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	930540	80.4%
1	149880	13.0%
2	44085	3.8%
3	16116	1.4%
4	7167	0.6%
5	3718	0.3%
6	2061	0.2%
7	1150	0.1%
8	681	0.1%
9	421	< 0.1%
Other values (21)	953	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	930540	80.4%
1	149880	13.0%
2	44085	3.8%
3	16116	1.4%
4	7167	0.6%
5	3718	0.3%
6	2061	0.2%
7	1150	0.1%
8	681	0.1%
9	421	< 0.1%

Value	Count	Frequency (%)
39	1	< 0.1%
30	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
25	2	< 0.1%
24	1	< 0.1%
22	3	< 0.1%
21	4	< 0.1%

inq_last_6mths
Real number (ℝ_≥0)

ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6521492567

Minimum	0
Maximum	8
Zeros	661742
Zeros (%)	57.2%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9316926401
Coefficient of variation (CV)	1.428649394
Kurtosis	3.278905143
Mean	0.6521492567
Median Absolute Deviation (MAD)	0
Skewness	1.69294849
Sum	754388
Variance	0.8680511757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	661742	57.2%
1	318057	27.5%
2	117027	10.1%
3	43281	3.7%
4	11738	1.0%
5	4125	0.4%
6	770	0.1%
7	19	< 0.1%
8	13	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	661742	57.2%
1	318057	27.5%
2	117027	10.1%
3	43281	3.7%
4	11738	1.0%
5	4125	0.4%
6	770	0.1%
7	19	< 0.1%
8	13	< 0.1%

Value	Count	Frequency (%)
8	13	< 0.1%
7	19	< 0.1%
6	770	0.1%
5	4125	0.4%
4	11738	1.0%
3	43281	3.7%
2	117027	10.1%
1	318057	27.5%
0	661742	57.2%

open_acc
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	83
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.68118696

Minimum	1
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	8
median	11
Q3	14
95-th percentile	22
Maximum	90
Range	89
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.5042328
Coefficient of variation (CV)	0.4712049229
Kurtosis	3.384592643
Mean	11.68118696
Median Absolute Deviation (MAD)	3
Skewness	1.302245563
Sum	13512470
Variance	30.29657872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	102226	8.8%
10	99687	8.6%
8	97897	8.5%
11	92525	8.0%
7	87558	7.6%
12	83287	7.2%
13	72691	6.3%
6	72297	6.2%
14	62109	5.4%
15	52001	4.5%
Other values (73)	334494	28.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	350	< 0.1%
2	3752	0.3%
3	13291	1.1%
4	31001	2.7%
5	51874	4.5%
6	72297	6.2%
7	87558	7.6%
8	97897	8.5%
9	102226	8.8%
10	99687	8.6%

Value	Count	Frequency (%)
90	1	< 0.1%
88	1	< 0.1%
86	1	< 0.1%
84	1	< 0.1%
82	1	< 0.1%
81	1	< 0.1%
80	2	< 0.1%
79	1	< 0.1%
77	1	< 0.1%
76	3	< 0.1%

pub_rec
Real number (ℝ_≥0)

ZEROS

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21453493

Minimum	0
Maximum	63
Zeros	961673
Zeros (%)	83.1%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	63
Range	63
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5975280812
Coefficient of variation (CV)	2.785225144
Kurtosis	456.647265
Mean	0.21453493
Median Absolute Deviation (MAD)	0
Skewness	9.729955051
Sum	248168
Variance	0.3570398078
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0	961673	83.1%
1	163132	14.1%
2	21069	1.8%
3	6371	0.6%
4	2279	0.2%
5	1087	0.1%
6	548	< 0.1%
7	241	< 0.1%
8	130	< 0.1%
9	68	< 0.1%
Other values (25)	174	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	961673	83.1%
1	163132	14.1%
2	21069	1.8%
3	6371	0.6%
4	2279	0.2%
5	1087	0.1%
6	548	< 0.1%
7	241	< 0.1%
8	130	< 0.1%
9	68	< 0.1%

Value	Count	Frequency (%)
63	1	< 0.1%
61	1	< 0.1%
49	2	< 0.1%
47	1	< 0.1%
46	1	< 0.1%
40	1	< 0.1%
37	1	< 0.1%
34	1	< 0.1%
28	3	< 0.1%
25	1	< 0.1%

revol_bal
Real number (ℝ_≥0)

Distinct	79704
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16182.97523

Minimum	0
Maximum	2904836
Zeros	4756
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1707
Q1	5945
median	11073
Q3	19593
95-th percentile	43269
Maximum	2904836
Range	2904836
Interquartile range (IQR)	13648

Descriptive statistics

Standard deviation	22347.68219
Coefficient of variation (CV)	1.380937799
Kurtosis	778.7699151
Mean	16182.97523
Median Absolute Deviation (MAD)	6090
Skewness	14.17206609
Sum	1.872001262 × 10¹⁰
Variance	499418899.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4756	0.4%
5235	96	< 0.1%
6312	89	< 0.1%
8	88	< 0.1%
6239	87	< 0.1%
5453	87	< 0.1%
2	87	< 0.1%
5249	86	< 0.1%
5314	86	< 0.1%
6118	85	< 0.1%
Other values (79694)	1151225	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4756	0.4%
1	53	< 0.1%
2	87	< 0.1%
3	74	< 0.1%
4	60	< 0.1%
5	61	< 0.1%
6	75	< 0.1%
7	62	< 0.1%
8	88	< 0.1%
9	63	< 0.1%

Value	Count	Frequency (%)
2904836	1	< 0.1%
2568995	1	< 0.1%
2560703	1	< 0.1%
1746716	1	< 0.1%
1696796	1	< 0.1%
1298783	1	< 0.1%
1190046	1	< 0.1%
1087664	1	< 0.1%
1044210	1	< 0.1%
1043860	1	< 0.1%

revol_util
Real number (ℝ_≥0)

Distinct	1325
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.77143175

Minimum	0
Maximum	892.3
Zeros	5672
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	10.6
Q1	33.4
median	52
Q3	70.6
95-th percentile	91.5
Maximum	892.3
Range	892.3
Interquartile range (IQR)	37.2

Descriptive statistics

Standard deviation	24.47262235
Coefficient of variation (CV)	0.4727051487
Kurtosis	0.4238643853
Mean	51.77143175
Median Absolute Deviation (MAD)	18.6
Skewness	-0.022792492
Sum	59887742.65
Variance	598.9092445
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5672	0.5%
53	2294	0.2%
57	2279	0.2%
54	2271	0.2%
48	2266	0.2%
58	2258	0.2%
59	2236	0.2%
52	2224	0.2%
61	2210	0.2%
56	2205	0.2%
Other values (1315)	1130857	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5672	0.5%
0.03	1	< 0.1%
0.05	1	< 0.1%
0.1	783	0.1%
0.12	1	< 0.1%
0.16	1	< 0.1%
0.2	624	0.1%
0.3	593	0.1%
0.4	514	< 0.1%
0.46	1	< 0.1%

Value	Count	Frequency (%)
892.3	1	< 0.1%
366.6	1	< 0.1%
193	1	< 0.1%
184.6	1	< 0.1%
182.8	1	< 0.1%
177.7	1	< 0.1%
172	1	< 0.1%
165.8	1	< 0.1%
162	1	< 0.1%
156.3	1	< 0.1%

total_acc
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	140
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.01253229

Minimum	2
Maximum	176
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	16
median	23
Q3	32
95-th percentile	47
Maximum	176
Range	174
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.02461624
Coefficient of variation (CV)	0.4807436567
Kurtosis	1.697894815
Mean	25.01253229
Median Absolute Deviation (MAD)	8
Skewness	0.9647115528
Sum	28933797
Variance	144.5913956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	41859	3.6%
21	41472	3.6%
19	41471	3.6%
22	41378	3.6%
18	40875	3.5%
23	40714	3.5%
17	40575	3.5%
24	39632	3.4%
16	38831	3.4%
25	38202	3.3%
Other values (130)	751763	65.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	280	< 0.1%
3	1099	0.1%
4	4105	0.4%
5	6725	0.6%
6	9878	0.9%
7	13320	1.2%
8	16879	1.5%
9	20559	1.8%
10	24130	2.1%
11	27527	2.4%

Value	Count	Frequency (%)
176	1	< 0.1%
169	1	< 0.1%
156	1	< 0.1%
151	2	< 0.1%
150	1	< 0.1%
146	2	< 0.1%
144	2	< 0.1%
141	1	< 0.1%
140	1	< 0.1%
138	1	< 0.1%

total_pymnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1087461
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14693.52947

Minimum	0
Maximum	63296.87792
Zeros	680
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	0
5-th percentile	2510.4665
Q1	6817.02
median	12025.62
Q3	20303.38367
95-th percentile	36153.77547
Maximum	63296.87792
Range	63296.87792
Interquartile range (IQR)	13486.36367

Descriptive statistics

Standard deviation	10241.98898
Coefficient of variation (CV)	0.6970407621
Kurtosis	0.7199555622
Mean	14693.52947
Median Absolute Deviation (MAD)	6054.549034
Skewness	1.057335482
Sum	1.699706348 × 10¹⁰
Variance	104898338.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	680	0.1%
10838.35484	174	< 0.1%
11258.43637	167	< 0.1%
13510.12859	151	< 0.1%
16257.52756	151	< 0.1%
16887.64456	126	< 0.1%
13006.0278	123	< 0.1%
27095.91178	118	< 0.1%
22516.86275	116	< 0.1%
21676.71967	109	< 0.1%
Other values (1087451)	1154857	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	680	0.1%
10	1	< 0.1%
16.58	1	< 0.1%
17.58	1	< 0.1%
25	3	< 0.1%
30	1	< 0.1%
30.86	1	< 0.1%
31.33	1	< 0.1%
32.36	1	< 0.1%
33.63	1	< 0.1%

Value	Count	Frequency (%)
63296.87792	1	< 0.1%
62862.50673	1	< 0.1%
62837.63969	1	< 0.1%
62760.91388	1	< 0.1%
62687.03089	1	< 0.1%
62686.38817	1	< 0.1%
62670.38232	1	< 0.1%
62663.61834	1	< 0.1%
62663.6183	1	< 0.1%
62451.00816	1	< 0.1%

application_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 MiB

Individual	1135954
Joint App	20818

Length

Max length	10
Median length	10
Mean length	9.982003368
Min length	9

Characters and Unicode

Total characters	11546902
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Joint App
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	1135954	98.2%
Joint App	20818	1.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
individual	1135954	96.5%
joint	20818	1.8%
app	20818	1.8%

Most occurring characters

Value	Count	Frequency (%)
i	2292726	19.9%
d	2271908	19.7%
n	1156772	10.0%
I	1135954	9.8%
v	1135954	9.8%
u	1135954	9.8%
a	1135954	9.8%
l	1135954	9.8%
p	41636	0.4%
J	20818	0.2%
Other values (4)	83272	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10348494	89.6%
Uppercase Letter	1177590	10.2%
Space Separator	20818	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2292726	22.2%
d	2271908	22.0%
n	1156772	11.2%
v	1135954	11.0%
u	1135954	11.0%
a	1135954	11.0%
l	1135954	11.0%
p	41636	0.4%
o	20818	0.2%
t	20818	0.2%

Uppercase Letter

Value	Count	Frequency (%)
I	1135954	96.5%
J	20818	1.8%
A	20818	1.8%

Space Separator

Value	Count	Frequency (%)
	20818	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11526084	99.8%
Common	20818	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2292726	19.9%
d	2271908	19.7%
n	1156772	10.0%
I	1135954	9.9%
v	1135954	9.9%
u	1135954	9.9%
a	1135954	9.9%
l	1135954	9.9%
p	41636	0.4%
J	20818	0.2%
Other values (3)	62454	0.5%

Common

Value	Count	Frequency (%)
	20818	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11546902	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	2292726	19.9%
d	2271908	19.7%
n	1156772	10.0%
I	1135954	9.8%
v	1135954	9.8%
u	1135954	9.8%
a	1135954	9.8%
l	1135954	9.8%
p	41636	0.4%
J	20818	0.2%
Other values (4)	83272	0.7%

fico
Real number (ℝ_≥0)

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	697.866188

Minimum	662
Maximum	847.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.8 MiB

Quantile statistics

Minimum	662
5-th percentile	662
Q1	672
median	692
Q3	712
95-th percentile	762
Maximum	847.5
Range	185.5
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	31.63904905
Coefficient of variation (CV)	0.04533684193
Kurtosis	1.729464154
Mean	697.866188
Median Absolute Deviation (MAD)	20
Skewness	1.299823685
Sum	807272066
Variance	1001.029425
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
662	104693	9.1%
672	101348	8.8%
667	101243	8.8%
677	90606	7.8%
682	89374	7.7%
687	78535	6.8%
692	76498	6.6%
697	68462	5.9%
702	62542	5.4%
707	56174	4.9%
Other values (28)	327297	28.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
662	104693	9.1%
667	101243	8.8%
672	101348	8.8%
677	90606	7.8%
682	89374	7.7%
687	78535	6.8%
692	76498	6.6%
697	68462	5.9%
702	62542	5.4%
707	56174	4.9%

Value	Count	Frequency (%)
847.5	154	< 0.1%
842	210	< 0.1%
837	335	< 0.1%
832	602	0.1%
827	896	0.1%
822	1168	0.1%
817	1580	0.1%
812	1997	0.2%
807	2791	0.2%
802	3219	0.3%

months_cr_line
Real number (ℝ_≥0)

Distinct	696
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	191.0901353

Minimum	35
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 MiB

Quantile statistics

Minimum	35
5-th percentile	73
Q1	133
median	174
Q3	236
95-th percentile	358
Maximum	999
Range	964
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	86.59279216
Coefficient of variation (CV)	0.453151556
Kurtosis	1.532438983
Mean	191.0901353
Median Absolute Deviation (MAD)	49
Skewness	1.027122193
Sum	221047718
Variance	7498.311654
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
144	10226	0.9%
157	9422	0.8%
155	9387	0.8%
141	8795	0.8%
130	8765	0.8%
146	8759	0.8%
164	8677	0.8%
132	8664	0.7%
153	8647	0.7%
151	8482	0.7%
Other values (686)	1066948	92.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
35	5	< 0.1%
36	300	< 0.1%
37	675	0.1%
38	1560	0.1%
39	1175	0.1%
40	1321	0.1%
41	1530	0.1%
42	1396	0.1%
43	1448	0.1%
44	1193	0.1%

Value	Count	Frequency (%)
999	1	< 0.1%
852	1	< 0.1%
851	1	< 0.1%
841	1	< 0.1%
821	1	< 0.1%
819	1	< 0.1%
803	1	< 0.1%
793	1	< 0.1%
786	1	< 0.1%
785	1	< 0.1%

ROI
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1084282
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	399.321193

Minimum	-40000
Maximum	28296.87792
Zeros	111
Zeros (%)	< 0.1%
Negative	209537
Negative (%)	18.1%
Memory size	8.8 MiB

Quantile statistics

Minimum	-40000
5-th percentile	-10475.19
Q1	268.7526887
median	1111.058756
Q3	2408.416563
95-th percentile	6537.777399
Maximum	28296.87792
Range	68296.87792
Interquartile range (IQR)	2139.663874

Descriptive statistics

Standard deviation	5283.968512
Coefficient of variation (CV)	13.23237686
Kurtosis	7.550560969
Mean	399.321193
Median Absolute Deviation (MAD)	1005.588309
Skewness	-1.919955349
Sum	461923575.1
Variance	27920323.24
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
838.3548364	174	< 0.1%
1258.436374	167	< 0.1%
1510.128586	151	< 0.1%
1257.527562	151	< 0.1%
1887.644562	126	< 0.1%
1006.027804	123	< 0.1%
2095.911784	118	< 0.1%
2516.862749	116	< 0.1%
0	111	< 0.1%
1676.719673	109	< 0.1%
Other values (1084272)	1155426	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-40000	23	< 0.1%
-39970	1	< 0.1%
-39800	1	< 0.1%
-39308.45	1	< 0.1%
-39217.66	1	< 0.1%
-39200	1	< 0.1%
-39182.07	1	< 0.1%
-39151.97	1	< 0.1%
-39137.06	1	< 0.1%
-39123.8	1	< 0.1%

Value	Count	Frequency (%)
28296.87792	1	< 0.1%
27862.50673	1	< 0.1%
27837.63969	1	< 0.1%
27760.91388	1	< 0.1%
27687.03089	1	< 0.1%
27686.38817	1	< 0.1%
27670.38232	1	< 0.1%
27663.61834	1	< 0.1%
27663.6183	1	< 0.1%
27451.00816	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	loan_amnt	term	installment	grade	emp_length	home_ownership	annual_inc	verification_status	loan_status	purpose	addr_state	dti	delinq_2yrs	inq_last_6mths	open_acc	pub_rec	revol_bal	revol_util	total_acc	total_pymnt	application_type	fico	months_cr_line	ROI
0	3600.0	36 months	123.03	3	10.0	MORTGAGE	55000.0	Not Verified	1	debt_consolidation	PA	5.91	0.0	1.0	7.0	0.0	2765.0	29.7	13.0	4421.723917	Individual	677.0	148	821.723917
1	24700.0	36 months	820.28	3	10.0	MORTGAGE	65000.0	Not Verified	1	small_business	SD	16.06	1.0	4.0	22.0	0.0	21470.0	19.2	38.0	25679.660000	Individual	717.0	192	979.660000
2	20000.0	60 months	432.66	2	10.0	MORTGAGE	63000.0	Not Verified	1	home_improvement	IL	10.78	0.0	0.0	6.0	0.0	7869.0	56.2	18.0	22705.924294	Joint App	697.0	183	2705.924294
3	10400.0	60 months	289.91	6	3.0	MORTGAGE	104433.0	Source Verified	1	major_purchase	PA	25.37	1.0	3.0	12.0	0.0	21929.0	64.5	35.0	11740.500000	Individual	697.0	210	1340.500000
4	11950.0	36 months	405.18	3	4.0	RENT	34000.0	Source Verified	1	debt_consolidation	GA	10.20	0.0	0.0	5.0	0.0	8822.0	68.4	6.0	13708.948530	Individual	692.0	338	1758.948530
5	20000.0	36 months	637.58	2	10.0	MORTGAGE	180000.0	Not Verified	1	debt_consolidation	MN	14.67	0.0	0.0	12.0	0.0	87329.0	84.5	27.0	21393.800000	Individual	682.0	306	1393.800000
6	20000.0	36 months	631.26	2	10.0	MORTGAGE	85000.0	Not Verified	1	major_purchase	SC	17.61	1.0	0.0	8.0	0.0	826.0	5.7	15.0	21538.508977	Individual	707.0	201	1538.508977
7	10000.0	36 months	306.45	1	6.0	RENT	85000.0	Not Verified	1	credit_card	PA	13.07	0.0	1.0	14.0	1.0	10464.0	34.5	23.0	10998.971575	Individual	687.0	164	998.971575
8	8000.0	36 months	263.74	2	10.0	MORTGAGE	42000.0	Not Verified	1	credit_card	RI	34.80	0.0	0.0	8.0	0.0	7034.0	39.1	18.0	8939.580503	Individual	702.0	252	939.580503
9	1400.0	36 months	47.10	3	3.0	MORTGAGE	64000.0	Not Verified	1	other	NC	34.95	0.0	0.0	17.0	0.0	37828.0	67.2	24.0	1575.160698	Individual	702.0	233	175.160698

Last rows

	loan_amnt	term	installment	grade	emp_length	home_ownership	annual_inc	verification_status	loan_status	purpose	addr_state	dti	delinq_2yrs	inq_last_6mths	open_acc	pub_rec	revol_bal	revol_util	total_acc	total_pymnt	application_type	fico	months_cr_line	ROI
1156762	16000.0	60 months	347.80	2	10.0	MORTGAGE	120000.0	Not Verified	1	debt_consolidation	NY	12.40	1.0	2.0	21.0	1.0	5995.0	7.6	34.0	18183.147643	Individual	747.0	150	2183.147643
1156763	11200.0	60 months	257.66	3	5.0	RENT	86000.0	Source Verified	0	debt_consolidation	WA	4.80	0.0	0.0	7.0	2.0	12581.0	54.7	14.0	6182.920000	Individual	667.0	270	-5017.080000
1156764	15000.0	36 months	487.47	2	8.0	MORTGAGE	60000.0	Not Verified	1	debt_consolidation	CO	26.40	0.0	0.0	24.0	0.0	48654.0	36.1	42.0	15908.001163	Individual	682.0	432	908.001163
1156765	36400.0	60 months	856.24	3	5.0	RENT	95000.0	Verified	0	credit_card	CA	21.50	0.0	0.0	11.0	0.0	55723.0	79.8	24.0	2539.420000	Individual	722.0	355	-33860.580000
1156766	23800.0	60 months	559.85	3	10.0	MORTGAGE	119000.0	Not Verified	1	debt_consolidation	OH	32.73	0.0	1.0	13.0	0.0	107747.0	89.5	29.0	29818.871195	Individual	687.0	290	6018.871195
1156767	18000.0	60 months	377.95	2	5.0	OWN	130000.0	Not Verified	1	home_improvement	TX	20.59	0.0	1.0	17.0	0.0	23833.0	34.0	39.0	20756.233632	Individual	737.0	147	2756.233632
1156768	29400.0	60 months	683.94	3	9.0	MORTGAGE	180792.0	Not Verified	1	debt_consolidation	CA	22.03	0.0	1.0	16.0	0.0	77480.0	85.2	32.0	35848.764532	Individual	707.0	175	6448.764532
1156769	32000.0	60 months	752.74	3	3.0	MORTGAGE	157000.0	Source Verified	0	home_improvement	AZ	10.34	0.0	0.0	14.0	0.0	111598.0	27.4	18.0	3737.940000	Individual	737.0	64	-28262.060000
1156770	16000.0	60 months	362.34	3	10.0	RENT	150000.0	Not Verified	1	medical	NC	12.25	0.0	0.0	12.0	4.0	7700.0	55.0	28.0	18660.607569	Individual	667.0	230	2660.607569
1156771	24000.0	60 months	564.56	3	6.0	RENT	110000.0	Not Verified	0	debt_consolidation	FL	18.30	0.0	0.0	10.0	1.0	17641.0	68.1	31.0	6755.400000	Individual	662.0	207	-17244.600000

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter